<If Loop>
   <IsFKey>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace wcf<Application>
{

public class <OwnerU>_<TableU>ComboService<MiscTag> : I<OwnerU>_<TableU>ComboService<MiscTag>
{

   <ExitLoop>
</If Loop>
<If Loop>
   <IsFKey>
    public List<<OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>> List<OwnerU>_<TableU>_<ROwnerU>_<RTableU><MiscTag>()
    {
        List<<OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>> <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List = new List<<OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>>();
        SqlConnection connection = <Database>DataService.GetConnection();
        string selectStatement 
            = "SELECT "  
            <IsFKey>
            + "     [<RField>] " 
            <IsFKey>
            <And>
            <IsRDisplayField>
            + "    ,[<RDisplayField>] " 
            <IsFKey>
            + "FROM " 
            + "     [<ROwner>].[<RTable>] " 
            <IsFKey>
            + "";
        SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
        try
        {
            connection.Open();
            SqlDataReader reader = selectCommand.ExecuteReader();
            <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag> cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU> = new <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>();
            while (reader.Read())
            {
                cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU> = new <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>();
                <IsFKey>
                cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU>.<RFieldU> = <Convert>(reader["<RField>"]);
                <IsFKey>
                <And>
                <IsRDisplayField>
                cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU>.<RDisplayFieldU> = Convert.ToString(reader["<RDisplayField>"]);
                <IsFKey>
                <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List.Add(cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU>);
            <IsFKey>
            }
            reader.Close();
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
        return <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List;
    }

</If Loop>
<If Loop>
   <IsFKey>
}

}
   <ExitLoop>
</If Loop>
